How to: Find a formula in a worksheet.
Solution:
Select 'Find...' from the 'Edit' menu, type the characters to be found in the 'Find What' box, and select 'Formulas' from the 'Look in' drop-down list.
1) Select the 'Edit' menu and select 'Find...'. (The Find dialog box appears.)
2) Type the characters contained in the formula to be found in the 'Find What' box.
NOTE: If the exact formula is unknown, use question marks (?) or asterisks (*). Question marks and asterisks are wildcard characters. A question mark is used to represent any single character while an asterisk is used to represent any number of characters. If searching for a question mark or asterisk, precede these characters with a tilde (~).
EXAMPLE: To search for a formula using the SUM() function (e.g., =SUM(C4,C8)), type the following: =SUM(??,??)
3) Select 'By Rows' or 'By Columns' from the 'Search' drop-down list.
4) Select 'Formulas' from the 'Look in' drop-down list.
5) (Optional) Select the 'Match Case' check box to find characters with cases that match exactly those typed in the 'Find What' box.
Finding a formula
6) (Optional) Select the 'Find Entire Cells Only' check box to find exact and complete matches only.
7) Click 'Find Next'.
8) Click 'Close' when the formula is found.
